home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 2003 May (DVD) / Macworld Resource DVD May 2003.toast / Data / Software / Bonus / Database / mysql-max-3.23.55.sit / mysql-max-3.23.55-apple-darwi.1 / mysql-test / t / outfile.test < prev    next >
Encoding:
Text File  |  2003-01-21  |  779 b   |  24 lines  |  [TEXT/ttxt]
  1. #
  2. # test of into outfile|dumpfile
  3. #
  4.  
  5. # We need to check that we have 'file' privilege.
  6.  
  7. #drop table if exists t1;
  8. #create table t1 (`a` blob);
  9. #insert into t1 values("hello world"),("Hello mars"),(NULL);
  10. #select * into outfile "/tmp/select-test.1" from t1;
  11. #select load_file("/tmp/select-test.1");
  12. #select * into dumpfile "/tmp/select-test.2" from t1 limit 1;
  13. #select load_file("/tmp/select-test.2");
  14. #select * into dumpfile "/tmp/select-test.3" from t1 where a is null;
  15. #select load_file("/tmp/select-test.3");
  16. #
  17. ## the following should give errors
  18. #
  19. #select * into outfile "/tmp/select-test.1" from t1;
  20. #select * into dumpfile "/tmp/select-test.1" from t1;
  21. #select * into dumpfile "/tmp/select-test.99" from t1;
  22. #select load_file("/tmp/select-test.not-exist");
  23. #drop table t1;
  24.